Iceberg | 您所在的位置:网站首页 › apache iceberg github › Iceberg |
IcebergIceberg使用限制支持 Iceberg V1/V2 表格式。V2 格式仅支持 Position Delete 方式,不支持 Equality Delete。创建 Catalog基于Hive Metastore创建Catalog 和 Hive Catalog 基本一致,这里仅给出简单示例。其他示例可参阅 Hive Catalog。 CREATE CATALOG iceberg PROPERTIES ( 'type'='hms', 'hive.metastore.uris' = 'thrift://172.21.0.1:7004', 'hadoop.username' = 'hive', 'dfs.nameservices'='your-nameservice', 'dfs.ha.namenodes.your-nameservice'='nn1,nn2', 'dfs.namenode.rpc-address.your-nameservice.nn1'='172.21.0.2:4007', 'dfs.namenode.rpc-address.your-nameservice.nn2'='172.21.0.3:4007', 'dfs.client.failover.proxy.provider.your-nameservice'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider');基于Iceberg API创建CatalogSinceVersion dev使用Iceberg API访问元数据的方式,支持Hive、REST、Glue等服务作为Iceberg的Catalog。 Hive Metastore作为元数据服务CREATE CATALOG iceberg PROPERTIES ( 'type'='iceberg', 'iceberg.catalog.type'='hms', 'hive.metastore.uris' = 'thrift://172.21.0.1:7004', 'hadoop.username' = 'hive', 'dfs.nameservices'='your-nameservice', 'dfs.ha.namenodes.your-nameservice'='nn1,nn2', 'dfs.namenode.rpc-address.your-nameservice.nn1'='172.21.0.2:4007', 'dfs.namenode.rpc-address.your-nameservice.nn2'='172.21.0.3:4007', 'dfs.client.failover.proxy.provider.your-nameservice'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider');Glue Catalog作为元数据服务CREATE CATALOG glue PROPERTIES ("type"="iceberg","iceberg.catalog.type" = "glue","glue.endpoint" = "https://glue.us-east-1.amazonaws.com","warehouse" = "s3://bucket/warehouse","AWS_ENDPOINT" = "s3.us-east-1.amazonaws.com","AWS_REGION" = "us-east-1","AWS_ACCESS_KEY" = "ak","AWS_SECRET_KEY" = "sk","use_path_style" = "true");glue.endpoint: Glue Endpoint. 参阅:AWS Glue endpoints and quotas. warehouse: Glue Warehouse Location. Glue Catalog的根路径,用于指定数据存放位置。 属性详情参见 Iceberg Glue Catalog REST Catalog作为元数据服务该方式需要预先提供REST服务,用户需实现获取Iceberg元数据的REST接口。 CREATE CATALOG iceberg PROPERTIES ( 'type'='iceberg', 'iceberg.catalog.type'='rest', 'uri' = 'http://172.21.0.1:8181',);若数据存放在S3上,properties中可以使用以下参数 "AWS_ACCESS_KEY" = "ak""AWS_SECRET_KEY" = "sk""AWS_REGION" = "region-name""AWS_ENDPOINT" = "http://endpoint-uri""AWS_CREDENTIALS_PROVIDER" = "provider-class-name" // 可选,默认凭证类基于BasicAWSCredentials实现。列类型映射和 Hive Catalog 一致,可参阅 Hive Catalog 中 列类型映射 一节。 Time TravelSinceVersion dev支持读取 Iceberg 表指定的 Snapshot。 每一次对iceberg表的写操作都会产生一个新的快照。 默认情况下,读取请求只会读取最新版本的快照。 可以使用 FOR TIME AS OF 和 FOR VERSION AS OF 语句,根据快照 ID 或者快照产生的时间读取历史版本的数据。示例如下: SELECT * FROM iceberg_tbl FOR TIME AS OF "2022-10-07 17:20:37"; SELECT * FROM iceberg_tbl FOR VERSION AS OF 868895038966572; 另外,可以使用 iceberg_meta 表函数查询指定表的 snapshot 信息。 |
CopyRight 2018-2019 实验室设备网 版权所有 |